SELECT node.nid AS nid,
   node_data_field_category_.field_category__value AS node_data_field_category__field_category__value,
   node.type AS node_type,
   node.vid AS node_vid,
   node_data_field_category_.field_code__value AS node_data_field_category__field_code__value,
   node_data_field_category_.field_descriptions__value AS node_data_field_category__field_descriptions__value,
   node_data_field_category_.field_fees__value AS node_data_field_category__field_fees__value,
   node_data_field_category_.field_metro_area__value AS node_data_field_category__field_metro_area__value,
   node_data_field_category_.field_state__value AS node_data_field_category__field_state__value
 FROM node node 
 INNER JOIN term_node term_node ON node.vid = term_node.vid
 LEFT JOIN content_type_dental_fees_data node_data_field_category_ ON node.vid = node_data_field_category_.vid
 WHERE (node.status <> 0) AND (term_node.tid = 127)